Node / meshtastic / Meshtastic-Android / files / core / database / src / androidHostTest / kotlin / org / meshtastic / core / database / dao / PacketFtsSearchTest.kt

Displaying Raw • Download

T8b949e/*

* Copyright (c) 2026 Meshtastic LLC

*

* This program is free software: you can redistribute it and/or modify

* it under the terms of the GNU General Public License as published by

* the Free Software Foundation, either version 3 of the License, or

* (at your option) any later version.

*

* This program is distributed in the hope that it will be useful,

* but WITHOUT ANY WARRANTY; without even the implied warranty of

* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

* GNU General Public License for more details.

*

* You should have received a copy of the GNU General Public License

* along with this program. If not, see <https://www.gnu.org/licenses/>.

*/

Tff7b72package T7ee787org.meshtastic.core.database.dao

Tff7b72import T7ee787androidx.room3.Room

Tff7b72import T7ee787androidx.sqlite.driver.bundled.BundledSQLiteDriver

Tff7b72import T7ee787androidx.test.core.app.ApplicationProvider

Tff7b72import T7ee787androidx.test.ext.junit.runners.AndroidJUnit4

Tff7b72import T7ee787kotlinx.coroutines.test.runTest

Tff7b72import T7ee787org.junit.After

Tff7b72import T7ee787org.junit.Before

Tff7b72import T7ee787org.junit.Test

Tff7b72import T7ee787org.junit.runner.RunWith

Tff7b72import T7ee787org.meshtastic.core.common.util.nowMillis

Tff7b72import T7ee787org.meshtastic.core.database.MeshtasticDatabase

Tff7b72import T7ee787org.meshtastic.core.database.MeshtasticDatabaseConstructor

Tff7b72import T7ee787org.meshtastic.core.database.entity.MyNodeEntity

Tff7b72import T7ee787org.meshtastic.core.database.entity.Packet

Tff7b72import T7ee787org.meshtastic.core.model.DataPacket

Tff7b72import T7ee787org.meshtastic.core.model.NodeAddress

Tff7b72import T7ee787org.meshtastic.proto.PortNum

Tff7b72import T7ee787org.robolectric.annotation.Config

Tff7b72import T7ee787kotlin.test.assertEquals

Tff7b72import T7ee787kotlin.test.assertTrue

T8b949e/**

* Verifies FTS5 full-text message search (#5373) and the historical-message backfill.

*

* [backfillMessageTexts_makesHistoricalMessagesSearchable] is the regression guard for the original `json_extract(data,

* '$.text')` backfill, which silently matched nothing: `DataPacket.text` is a computed property and is never serialized

* into the stored JSON, so historical messages stayed permanently unsearchable.

*/

Tf0883e@RunWithTb4b4b4(Te6edf3AndroidJUnit4Tff7b72::Te6edf3classTb4b4b4)

Tf0883e@ConfigTb4b4b4(Te6edf3sdk Tff7b72= Tff7b72[T79c0ff3T79c0ff4Tff7b72]Tb4b4b4)

Tff7b72class T56d364PacketFtsSearchTest Tb4b4b4{

Tff7b72private Tff7b72lateinit Tff7b72var Te6edf3databaseTb4b4b4: Te6edf3MeshtasticDatabase

Tff7b72private Tff7b72lateinit Tff7b72var Te6edf3packetDaoTb4b4b4: Te6edf3PacketDao

Tff7b72private Tff7b72lateinit Tff7b72var Te6edf3nodeInfoDaoTb4b4b4: Te6edf3NodeInfoDao

Tff7b72private Tff7b72val Te6edf3myNodeNum Tff7b72= T79c0ff4T79c0ff2T79c0ff4T79c0ff2T79c0ff4T79c0ff2T79c0ff4T79c0ff2

Tff7b72private Tff7b72val Te6edf3myNodeInfo Tff7b72=

Te6edf3MyNodeEntityTb4b4b4(

Te6edf3myNodeNum Tff7b72= Te6edf3myNodeNumTb4b4b4,

Te6edf3model Tff7b72= Tff7b72nullTb4b4b4,

Te6edf3firmwareVersion Tff7b72= Tff7b72nullTb4b4b4,

Te6edf3couldUpdate Tff7b72= Tff7b72falseTb4b4b4,

Te6edf3shouldUpdate Tff7b72= Tff7b72falseTb4b4b4,

Te6edf3currentPacketId Tff7b72= T79c0ff1LTb4b4b4,

Te6edf3messageTimeoutMsec Tff7b72= T79c0ff5 Tff7b72* T79c0ff6T79c0ff0 Tff7b72* T79c0ff1T79c0ff0T79c0ff0T79c0ff0Tb4b4b4,

Te6edf3minAppVersion Tff7b72= T79c0ff1Tb4b4b4,

Te6edf3maxChannels Tff7b72= T79c0ff8Tb4b4b4,

Te6edf3hasWifi Tff7b72= Tff7b72falseTb4b4b4,

Tb4b4b4)

Tf0883e@Before

Tff7b72fun Td2a8ffcreateDbTb4b4b4(Tb4b4b4)Tb4b4b4: Tffa657Unit Tff7b72= Te6edf3runTest Tb4b4b4{

Tff7b72val Te6edf3context Tff7b72= Te6edf3ApplicationProviderTb4b4b4.Te6edf3getApplicationContextTff7b72<Te6edf3androidTb4b4b4.Te6edf3contentTb4b4b4.Te6edf3ContextTff7b72>Tb4b4b4(Tb4b4b4)

Te6edf3database Tff7b72=

Te6edf3RoomTb4b4b4.Te6edf3inMemoryDatabaseBuilderTff7b72<Te6edf3MeshtasticDatabaseTff7b72>Tb4b4b4(

Te6edf3context Tff7b72= Te6edf3contextTb4b4b4,

Te6edf3factory Tff7b72= Tb4b4b4{ Te6edf3MeshtasticDatabaseConstructorTb4b4b4.Te6edf3initializeTb4b4b4(Tb4b4b4) Tb4b4b4}Tb4b4b4,

Tb4b4b4)

Tb4b4b4.Te6edf3setDriverTb4b4b4(Te6edf3BundledSQLiteDriverTb4b4b4(Tb4b4b4)Tb4b4b4)

Tb4b4b4.Te6edf3buildTb4b4b4(Tb4b4b4)

Te6edf3nodeInfoDao Tff7b72= Te6edf3databaseTb4b4b4.Te6edf3nodeInfoDaoTb4b4b4(Tb4b4b4)Tb4b4b4.Te6edf3apply Tb4b4b4{ Te6edf3setMyNodeInfoTb4b4b4(Te6edf3myNodeInfoTb4b4b4) Tb4b4b4}

Te6edf3packetDao Tff7b72= Te6edf3databaseTb4b4b4.Te6edf3packetDaoTb4b4b4(Tb4b4b4)

Tb4b4b4}

Tf0883e@After

Tff7b72fun Td2a8ffcloseDbTb4b4b4(Tb4b4b4) Tb4b4b4{

Te6edf3databaseTb4b4b4.Te6edf3closeTb4b4b4(Tb4b4b4)

Tb4b4b4}

Tf0883e@Test

Tff7b72fun Td2a8ffsearchMessages_matchesIndexedText_ignoresNonMatchesTb4b4b4(Tb4b4b4) Tff7b72= Te6edf3runTest Tb4b4b4{

Te6edf3insertTextPacketTb4b4b4(Te6edf3contactKey Tff7b72= Te6edf3CONTACTTb4b4b4, Te6edf3text Tff7b72= Ta5d6ff"Ta5d6ffthe quick brown foxTa5d6ff"Tb4b4b4, Te6edf3messageText Tff7b72= Ta5d6ff"Ta5d6ffthe quick brown foxTa5d6ff"Tb4b4b4)

Te6edf3assertEqualsTb4b4b4(T79c0ff1Tb4b4b4, Te6edf3packetDaoTb4b4b4.Te6edf3searchMessagesTb4b4b4(Ta5d6ff"Ta5d6ffbrownTa5d6ff"Tb4b4b4)Tb4b4b4.Te6edf3sizeTb4b4b4, Ta5d6ff"Ta5d6ffa term in the indexed message should matchTa5d6ff"Tb4b4b4)

Te6edf3assertTrueTb4b4b4(Te6edf3packetDaoTb4b4b4.Te6edf3searchMessagesTb4b4b4(Ta5d6ff"Ta5d6ffzebraTa5d6ff"Tb4b4b4)Tb4b4b4.Te6edf3isEmptyTb4b4b4(Tb4b4b4)Tb4b4b4, Ta5d6ff"Ta5d6ffan absent term should not matchTa5d6ff"Tb4b4b4)

Tb4b4b4}

Tf0883e@Test

Tff7b72fun Td2a8ffsearchMessagesInConversation_scopesToContactTb4b4b4(Tb4b4b4) Tff7b72= Te6edf3runTest Tb4b4b4{

Te6edf3insertTextPacketTb4b4b4(Te6edf3contactKey Tff7b72= Te6edf3CONTACTTb4b4b4, Te6edf3text Tff7b72= Ta5d6ff"Ta5d6ffshared keyword hereTa5d6ff"Tb4b4b4, Te6edf3messageText Tff7b72= Ta5d6ff"Ta5d6ffshared keyword hereTa5d6ff"Tb4b4b4)

Te6edf3insertTextPacketTb4b4b4(Te6edf3contactKey Tff7b72= Te6edf3OTHER_CONTACTTb4b4b4, Te6edf3text Tff7b72= Ta5d6ff"Ta5d6ffshared keyword hereTa5d6ff"Tb4b4b4, Te6edf3messageText Tff7b72= Ta5d6ff"Ta5d6ffshared keyword hereTa5d6ff"Tb4b4b4)

Te6edf3assertEqualsTb4b4b4(T79c0ff2Tb4b4b4, Te6edf3packetDaoTb4b4b4.Te6edf3searchMessagesTb4b4b4(Ta5d6ff"Ta5d6ffkeywordTa5d6ff"Tb4b4b4)Tb4b4b4.Te6edf3sizeTb4b4b4, Ta5d6ff"Ta5d6ffboth conversations match the global searchTa5d6ff"Tb4b4b4)

Te6edf3assertEqualsTb4b4b4(T79c0ff1Tb4b4b4, Te6edf3packetDaoTb4b4b4.Te6edf3searchMessagesInConversationTb4b4b4(Ta5d6ff"Ta5d6ffkeywordTa5d6ff"Tb4b4b4, Te6edf3CONTACTTb4b4b4)Tb4b4b4.Te6edf3sizeTb4b4b4, Ta5d6ff"Ta5d6ffscoped to one contactTa5d6ff"Tb4b4b4)

Tb4b4b4}

Tf0883e@Test

Tff7b72fun Td2a8ffbackfillMessageTexts_makesHistoricalMessagesSearchableTb4b4b4(Tb4b4b4) Tff7b72= Te6edf3runTest Tb4b4b4{

T8b949e// A pre-v39 packet: the payload carries the text, but message_text was never populated, so it is unindexed.

Te6edf3insertTextPacketTb4b4b4(Te6edf3contactKey Tff7b72= Te6edf3CONTACTTb4b4b4, Te6edf3text Tff7b72= Ta5d6ff"Ta5d6ffhistorical needleTa5d6ff"Tb4b4b4, Te6edf3messageText Tff7b72= Ta5d6ff"Ta5d6ff"Tb4b4b4)

Te6edf3assertTrueTb4b4b4(Te6edf3packetDaoTb4b4b4.Te6edf3searchMessagesTb4b4b4(Ta5d6ff"Ta5d6ffneedleTa5d6ff"Tb4b4b4)Tb4b4b4.Te6edf3isEmptyTb4b4b4(Tb4b4b4)Tb4b4b4, Ta5d6ff"Ta5d6ffthe historical message is unindexed before backfillTa5d6ff"Tb4b4b4)

Te6edf3assertEqualsTb4b4b4(T79c0ff1Tb4b4b4, Te6edf3packetDaoTb4b4b4.Te6edf3countPacketsNeedingBackfillTb4b4b4(Tb4b4b4)Tb4b4b4, Ta5d6ff"Ta5d6ffthe empty-message_text packet needs backfillTa5d6ff"Tb4b4b4)

Tff7b72val Te6edf3updated Tff7b72= Te6edf3packetDaoTb4b4b4.Te6edf3backfillMessageTextsTb4b4b4(Tb4b4b4)

Te6edf3packetDaoTb4b4b4.Te6edf3rebuildFtsIndexTb4b4b4(Tb4b4b4)

Te6edf3assertEqualsTb4b4b4(T79c0ff1Tb4b4b4, Te6edf3updatedTb4b4b4, Ta5d6ff"Ta5d6ffthe historical text packet should be backfilledTa5d6ff"Tb4b4b4)

Te6edf3assertEqualsTb4b4b4(T79c0ff1Tb4b4b4, Te6edf3packetDaoTb4b4b4.Te6edf3searchMessagesTb4b4b4(Ta5d6ff"Ta5d6ffneedleTa5d6ff"Tb4b4b4)Tb4b4b4.Te6edf3sizeTb4b4b4, Ta5d6ff"Ta5d6ffthe backfilled message should now be searchableTa5d6ff"Tb4b4b4)

Te6edf3assertEqualsTb4b4b4(T79c0ff0Tb4b4b4, Te6edf3packetDaoTb4b4b4.Te6edf3countPacketsNeedingBackfillTb4b4b4(Tb4b4b4)Tb4b4b4, Ta5d6ff"Ta5d6ffnothing left to backfillTa5d6ff"Tb4b4b4)

Tb4b4b4}

Tff7b72private Tff7b72suspend Tff7b72fun Td2a8ffinsertTextPacketTb4b4b4(Te6edf3contactKeyTb4b4b4: Tffa657StringTb4b4b4, Te6edf3textTb4b4b4: Tffa657StringTb4b4b4, Te6edf3messageTextTb4b4b4: Tffa657StringTb4b4b4) Tb4b4b4{

Te6edf3packetDaoTb4b4b4.Te6edf3insertTb4b4b4(

Te6edf3PacketTb4b4b4(

Te6edf3uuid Tff7b72= T79c0ff0LTb4b4b4,

Te6edf3myNodeNum Tff7b72= Te6edf3myNodeNumTb4b4b4,

Te6edf3port_num Tff7b72= Te6edf3PortNumTb4b4b4.Te6edf3TEXT_MESSAGE_APPTb4b4b4.Te6edf3valueTb4b4b4,

Te6edf3contact_key Tff7b72= Te6edf3contactKeyTb4b4b4,

Te6edf3received_time Tff7b72= Te6edf3nowMillisTb4b4b4,

Te6edf3read Tff7b72= Tff7b72falseTb4b4b4,

Te6edf3data Tff7b72= Te6edf3DataPacketTb4b4b4(Te6edf3to Tff7b72= Te6edf3NodeAddressTb4b4b4.Te6edf3ID_BROADCASTTb4b4b4, Te6edf3channel Tff7b72= T79c0ff0Tb4b4b4, Te6edf3text Tff7b72= Te6edf3textTb4b4b4)Tb4b4b4,

Te6edf3messageText Tff7b72= Te6edf3messageTextTb4b4b4,

Tb4b4b4)Tb4b4b4,

Tb4b4b4)

Tb4b4b4}

Tff7b72companion Tff7b72object Tb4b4b4{

Tff7b72private Tff7b72const Tff7b72val Te6edf3CONTACT Tff7b72= Ta5d6ff"Ta5d6ff0!aaaa1111Ta5d6ff"

Tff7b72private Tff7b72const Tff7b72val Te6edf3OTHER_CONTACT Tff7b72= Ta5d6ff"Ta5d6ff0!bbbb2222Ta5d6ff"

Tb4b4b4}

Tb4b4b4}